package com.groupseven.backend.mapper;

import com.groupseven.backend.domain.PrizeProduct.PrizeProduct;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface PrizeProductMapper {
    List<PrizeProduct> getallPrizeProduct();

    PrizeProduct getPrizeProductByPrizeProductNumber(String PrizeProductNumber);

    int addPrizeProduct(PrizeProduct prizeProduct);

    int updatePrizeProduct(PrizeProduct prizeProduct);

    int deleteallPrizeProduct();

    int deleteByPrizeProductNumber(String PrizeProductNumber);

    List<PrizeProduct> selectMyAwardsForAssessment(String username);

    /////////////////////////////////////////
    int mutildelPrizeProducts(List<String> PrizeProductNumbers);

    List<PrizeProduct> getlikePrizeProductByPrizeProductNumber(String PrizeProductNumber);

    List<PrizeProduct> getlikePrizeProductByPrizeProductName(String ProductName);

    List<PrizeProduct> getlikePrizeProductByusername(String username);

    List<PrizeProduct> getlikePrizeProductByPrizeAllauthors(String PrizeAllauthors);
    //////////////////////////////////////////

    /////////////////////////////////
    List<PrizeProduct> searchqueryPrizeProduct(String query);
    ///////////////////////////////

    String getProgramNumber(String ProgramNumber);

    //////////////////////////////////////////
    List<PrizeProduct> searchuserqueryPrizeProduct (String query, String username);
    //////////////////////////////////////

    List<PrizeProduct> selectMyAwards(String username);
}
